Using Access 2013 32-bit on a Windows Server 2008 R2 Enterprise. This computer has 8 GB of RAM.

I am getting:

"System Resource Exceeded"  errors in two different databases for simple queries like:

SELECT FROM .... GROUP BY ...

UPDATE... SET ... WHERE ...

I compacted the databases several times, no result. One database size is approx 1 GB, the other one is approx. 600 MB.

I didn't have any problems in Office 2010 so I had to revert to this version.

Please advise.

Regards,

M.R.

• Edited by MR1000 Wednesday, May 22, 2013 3:11 PM

Hi,

Try to install the hotfix in the following link to check the issue:

http://support.microsoft.com/kb/2760362

I tried your suggestion but got the message " The update is already installed on this system"

Hi,

Then try to start Access 2013 in safe mode to check whether the issue is caused by some add-ins.

I have the same problem. I run an application that works well under XP and Access 2003, also under W7 and 2003 on selected machines. On others it just stops. I migrated the application to Access 2013 64 bit (also W7 64 bit), but gets the same problem. However, now I get the "System Resources Exceeded" error which is an improvement over an application that just stops. I have downloaded the HOT fix, set the registry keys that were recommended, but still get the error. There are about 30 000 records in the table when the error occurs (but about the double in the 2003 version that works perfectly). If I reduce the number of records to about 20 000, everything is fine.

I have monitored memory usage which lies around 2.2 Gb (there is 8 installed). To me it seems that this must have something to do with systems settings, since it works on other machines.  Makes me miss XP and Access 2003!

Was any solution found for this issue? We are receiving this error as well on very simple queries (appending and deleting data around 40,000 records).  This issue never occurred in 2007 and began after we upgraded to 2013.  The hotfix actually worked for one process, but the error is still occurring in two others. 

  I am getting this error under Access 2010 and Windows 2012R2.

  We are using the most recent runtimes and libraries which are newer than the hotfix.

  We tried adding the registry key from the hotfix and are still getting the error.

     Greg